<?php
class Faculty_Status_Model extends CI_Model {
    //exp_fmis_member_status


	public function __construct(){
		parent::__construct();
	}

    public function getAll()
    {
        $sql = "SELECT * FROM exp_fmis_member_status";
        $query =  $this->db->query($sql);
        $result = $query->result_array();
        return $result;
    }

    public function getById($id = 0)
    {
        $sql = "SELECT * FROM exp_fmis_member_status WHERE ID LIKE ?";
        $query =  $this->db->query($sql, $id);
        $result = $query->row_array();
        return $result;
    }

    public function getStatusById($id)
    {
        $sql = "SELECT Description FROM exp_fmis_member_status WHERE ID LIKE ?";
        $query =  $this->db->query($sql, $id);
        $result = $query->result();
        return $result;
    }

}
